oracle 按照日期求和,如题 001 630001 01 20130105 400 001 630001 01...答:with t as(select to_char(t1.rq,'yyyymmdd') rq,b.COMPANY,b.AGENCYID,b.PRODUCTID,0 FYP from (select to_date('20130101','yyyymmdd') + rownum-1 rq from dual connect by rownum<=100) t1,b where t1.rq<=to_date('20130131','yyyymmdd') group by to_char(t1.rq,'yyyymmdd')...